﻿CREATE TABLE [ohrs].[Doctor] (
    [Id]             INT            IDENTITY (1, 1) NOT NULL,
    [PersonId]       INT            NOT NULL,
    [Name]           NVARCHAR (128) NOT NULL,
    [specialization] NVARCHAR (50)  NULL,
    CONSTRAINT [PK_Doctor] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Doctor_Person] FOREIGN KEY ([PersonId]) REFERENCES [enterprise].[Person] ([Id])
);



